USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'employ_info') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE employ_info 
  END 

go 

CREATE TABLE employ_info 
  ( 
     eid       VARCHAR(10) NOT NULL, 
     ename     NVARCHAR(10) NOT NULL, 
     esex      NVARCHAR(1) NOT NULL, 
     ebirthday VARCHAR(10), 
     ecard     VARCHAR(20) NOT NULL, 
     etel      VARCHAR(11) NOT NULL, 
     eaddress  NVARCHAR(50), 
     pid       INT NOT NULL, 
     scid      INT NOT NULL, 
     ewage     MONEY, 
     entertime VARCHAR(20), 
     nowstate  VARCHAR(5), 
     dimission VARCHAR(50), 
     eresume   NVARCHAR(200), 
     remark    NVARCHAR(200), 
     ephoto    IMAGE 
     PRIMARY KEY CLUSTERED ( eid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 